import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
import warnings
warnings.filterwarnings('ignore')
data=pd.read_excel('bank.xls')
print(data.head())
df1=data[data['贷款期限']==36]
df2=data[data['还款状态']=='A']
df3=data[(data['贷款期限']==36)&(data['还款状态']=='A')]
print(df1)
print(df2)
print(df3)

sns.countplot(x=data['还款状态'])
plt.show()

plt.plot(data.head(10)['贷款金额'])
plt.show()